﻿CREATE TABLE [timer].[hlpTimer] (
    [FileID]     BIGINT         IDENTITY (1, 1) NOT NULL,
    [FileName]   NVARCHAR (150) NOT NULL,
    [SetDate]    DATETIME2 (7)  NOT NULL,
    [TimerCount] INT            NOT NULL,
    [UserID]     INT            NOT NULL,
    CONSTRAINT [PK_timer_hlpTimer] PRIMARY KEY CLUSTERED ([FileID] ASC)
);


GO
CREATE NONCLUSTERED INDEX [timer_hlpTimer_IX_FileName]
    ON [timer].[hlpTimer]([FileName] ASC);

